Overview
Brought to you by YData
Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 3982 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 88 |
| Duplicate rows (%) | 2.2% |
| Total size in memory | 311.2 KiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 1 |
| Dataset has 88 (2.2%) duplicate rows | Duplicates |
bedrooms is highly overall correlated with sqft_living | High correlation |
grade is highly overall correlated with price and 1 other fields | High correlation |
price is highly overall correlated with grade and 4 other fields | High correlation |
sqft_basement is highly overall correlated with price and 1 other fields | High correlation |
sqft_living is highly overall correlated with bedrooms and 3 other fields | High correlation |
sqft_lot is highly overall correlated with price | High correlation |
yr_built is highly overall correlated with price | High correlation |
sqft_basement has 196 (4.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-09 02:03:41.696608 |
|---|---|
| Analysis finished | 2024-12-09 02:03:48.706459 |
| Duration | 7.01 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
date
Real number (ℝ)
| Distinct | 325 |
|---|---|
| Distinct (%) | 8.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 160692.29 |
| Minimum | 160102 |
|---|---|
| Maximum | 161230 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 160102 |
|---|---|
| 5-th percentile | 160201 |
| Q1 | 160427 |
| median | 160707 |
| Q3 | 160928 |
| 95-th percentile | 161209 |
| Maximum | 161230 |
| Range | 1128 |
| Interquartile range (IQR) | 501 |
Descriptive statistics
| Standard deviation | 313.81388 |
|---|---|
| Coefficient of variation (CV) | 0.001952887 |
| Kurtosis | -1.000792 |
| Mean | 160692.29 |
| Median Absolute Deviation (MAD) | 277.5 |
| Skewness | -0.019729271 |
| Sum | 6.3987669 × 108 |
| Variance | 98479.154 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160519 | 39 | 1.0% |
| 160526 | 36 | 0.9% |
| 160525 | 33 | 0.8% |
| 160427 | 31 | 0.8% |
| 160928 | 30 | 0.8% |
| 160609 | 30 | 0.8% |
| 160428 | 30 | 0.8% |
| 160613 | 29 | 0.7% |
| 160711 | 29 | 0.7% |
| 160518 | 28 | 0.7% |
| Other values (315) | 3667 |
| Value | Count | Frequency (%) |
| 160102 | 1 | < 0.1% |
| 160103 | 1 | < 0.1% |
| 160104 | 6 | 0.2% |
| 160105 | 7 | |
| 160106 | 7 | |
| 160107 | 7 | |
| 160108 | 8 | |
| 160111 | 5 | 0.1% |
| 160112 | 16 | |
| 160113 | 13 |
| Value | Count | Frequency (%) |
| 161230 | 7 | 0.2% |
| 161229 | 11 | |
| 161228 | 11 | |
| 161227 | 11 | |
| 161226 | 1 | < 0.1% |
| 161223 | 5 | 0.1% |
| 161222 | 11 | |
| 161221 | 14 | |
| 161220 | 18 | |
| 161219 | 11 |
floors
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.2 KiB |
| 1 | |
|---|---|
| 2 | |
| 1.5 | |
| 3 | 196 |
| RR | 13 |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.1730286 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 1.5 |
| 5th row | 1.5 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2422 | |
| 2 | 1013 | |
| 1.5 | 329 | 8.3% |
| 3 | 196 | 4.9% |
| RR | 13 | 0.3% |
| 2.5 | 9 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2422 | |
| 2 | 1013 | |
| 1.5 | 329 | 8.3% |
| 3 | 196 | 4.9% |
| rr | 13 | 0.3% |
| 2.5 | 9 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2751 | |
| 2 | 1022 | 21.9% |
| . | 338 | 7.2% |
| 5 | 338 | 7.2% |
| 3 | 196 | 4.2% |
| R | 26 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4671 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2751 | |
| 2 | 1022 | 21.9% |
| . | 338 | 7.2% |
| 5 | 338 | 7.2% |
| 3 | 196 | 4.2% |
| R | 26 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4671 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2751 | |
| 2 | 1022 | 21.9% |
| . | 338 | 7.2% |
| 5 | 338 | 7.2% |
| 3 | 196 | 4.2% |
| R | 26 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4671 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2751 | |
| 2 | 1022 | 21.9% |
| . | 338 | 7.2% |
| 5 | 338 | 7.2% |
| 3 | 196 | 4.2% |
| R | 26 | 0.6% |
bedrooms
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.820442 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.66047413 |
|---|---|
| Coefficient of variation (CV) | 0.23417398 |
| Kurtosis | 1.1575987 |
| Mean | 2.820442 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.19148611 |
| Sum | 11231 |
| Variance | 0.43622608 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 2423 | |
| 2 | 1072 | |
| 4 | 395 | 9.9% |
| 1 | 57 | 1.4% |
| 5 | 29 | 0.7% |
| 6 | 6 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 57 | 1.4% |
| 2 | 1072 | |
| 3 | 2423 | |
| 4 | 395 | 9.9% |
| 5 | 29 | 0.7% |
| 6 | 6 | 0.2% |
| Value | Count | Frequency (%) |
| 6 | 6 | 0.2% |
| 5 | 29 | 0.7% |
| 4 | 395 | 9.9% |
| 3 | 2423 | |
| 2 | 1072 | |
| 1 | 57 | 1.4% |
sqft_living
Real number (ℝ)
High correlation
| Distinct | 1420 |
|---|---|
| Distinct (%) | 35.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1461.3546 |
| Minimum | 520 |
|---|---|
| Maximum | 7391 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 816 |
| Q1 | 1064 |
| median | 1327.5 |
| Q3 | 1704 |
| 95-th percentile | 2509 |
| Maximum | 7391 |
| Range | 6871 |
| Interquartile range (IQR) | 640 |
Descriptive statistics
| Standard deviation | 580.01113 |
|---|---|
| Coefficient of variation (CV) | 0.39689965 |
| Kurtosis | 10.319984 |
| Mean | 1461.3546 |
| Median Absolute Deviation (MAD) | 304 |
| Skewness | 2.1599112 |
| Sum | 5819114 |
| Variance | 336412.91 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 936 | 33 | 0.8% |
| 864 | 28 | 0.7% |
| 768 | 28 | 0.7% |
| 1028 | 28 | 0.7% |
| 816 | 27 | 0.7% |
| 1080 | 27 | 0.7% |
| 1008 | 27 | 0.7% |
| 720 | 26 | 0.7% |
| 825 | 26 | 0.7% |
| 775 | 26 | 0.7% |
| Other values (1410) | 3706 |
| Value | Count | Frequency (%) |
| 520 | 1 | < 0.1% |
| 522 | 1 | < 0.1% |
| 572 | 1 | < 0.1% |
| 576 | 1 | < 0.1% |
| 580 | 1 | < 0.1% |
| 588 | 1 | < 0.1% |
| 608 | 1 | < 0.1% |
| 621 | 5 | |
| 624 | 3 | |
| 633 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7391 | 1 | |
| 7071 | 1 | |
| 5952 | 1 | |
| 5785 | 1 | |
| 5546 | 2 | |
| 5169 | 1 | |
| 5026 | 1 | |
| 4815 | 1 | |
| 4689 | 1 | |
| 4464 | 1 |
sqft_lot
Real number (ℝ)
High correlation
| Distinct | 174 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16552.039 |
| Minimum | 1307 |
|---|---|
| Maximum | 892980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 1307 |
|---|---|
| 5-th percentile | 5227 |
| Q1 | 6970 |
| median | 8276 |
| Q3 | 10454 |
| 95-th percentile | 21780 |
| Maximum | 892980 |
| Range | 891673 |
| Interquartile range (IQR) | 3484 |
Descriptive statistics
| Standard deviation | 52778.972 |
|---|---|
| Coefficient of variation (CV) | 3.188669 |
| Kurtosis | 136.92637 |
| Mean | 16552.039 |
| Median Absolute Deviation (MAD) | 1742 |
| Skewness | 10.469048 |
| Sum | 65910218 |
| Variance | 2.7856199 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6970 | 395 | 9.9% |
| 6534 | 319 | 8.0% |
| 7405 | 305 | 7.7% |
| 9148 | 287 | 7.2% |
| 8276 | 281 | 7.1% |
| 6098 | 257 | 6.5% |
| 7841 | 256 | 6.4% |
| 8712 | 244 | 6.1% |
| 9583 | 187 | 4.7% |
| 10454 | 156 | 3.9% |
| Other values (164) | 1295 |
| Value | Count | Frequency (%) |
| 1307 | 2 | 0.1% |
| 1742 | 5 | 0.1% |
| 2178 | 7 | 0.2% |
| 2614 | 8 | 0.2% |
| 3049 | 14 | 0.4% |
| 3485 | 23 | |
| 3920 | 14 | 0.4% |
| 4356 | 43 | |
| 4792 | 37 | |
| 5227 | 50 |
| Value | Count | Frequency (%) |
| 892980 | 1 | |
| 876863 | 1 | |
| 872942 | 2 | |
| 871636 | 1 | |
| 832867 | 1 | |
| 811523 | 1 | |
| 586753 | 1 | |
| 568022 | 1 | |
| 513137 | 1 | |
| 426888 | 1 |
sqft_basement
Real number (ℝ)
High correlation Zeros
| Distinct | 1175 |
|---|---|
| Distinct (%) | 29.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1045.0068 |
| Minimum | 0 |
|---|---|
| Maximum | 4635 |
| Zeros | 196 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 201 |
| Q1 | 763 |
| median | 1020 |
| Q3 | 1324 |
| 95-th percentile | 1828 |
| Maximum | 4635 |
| Range | 4635 |
| Interquartile range (IQR) | 561 |
Descriptive statistics
| Standard deviation | 480.14676 |
|---|---|
| Coefficient of variation (CV) | 0.4594676 |
| Kurtosis | 1.5825232 |
| Mean | 1045.0068 |
| Median Absolute Deviation (MAD) | 279 |
| Skewness | 0.37409712 |
| Sum | 4161217 |
| Variance | 230540.91 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 196 | 4.9% |
| 720 | 52 | 1.3% |
| 768 | 51 | 1.3% |
| 936 | 50 | 1.3% |
| 864 | 44 | 1.1% |
| 528 | 42 | 1.1% |
| 672 | 41 | 1.0% |
| 480 | 36 | 0.9% |
| 816 | 36 | 0.9% |
| 432 | 32 | 0.8% |
| Other values (1165) | 3402 |
| Value | Count | Frequency (%) |
| 0 | 196 | |
| 176 | 1 | < 0.1% |
| 180 | 1 | < 0.1% |
| 200 | 2 | 0.1% |
| 220 | 1 | < 0.1% |
| 250 | 1 | < 0.1% |
| 268 | 1 | < 0.1% |
| 286 | 2 | 0.1% |
| 288 | 1 | < 0.1% |
| 298 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4635 | 1 | |
| 3807 | 1 | |
| 3040 | 1 | |
| 2963 | 1 | |
| 2931 | 1 | |
| 2914 | 1 | |
| 2807 | 2 | |
| 2799 | 1 | |
| 2753 | 1 | |
| 2676 | 1 |
yr_built
Real number (ℝ)
High correlation
| Distinct | 117 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1977.1135 |
| Minimum | 1850 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 1850 |
|---|---|
| 5-th percentile | 1916.05 |
| Q1 | 1955 |
| median | 1981 |
| Q3 | 2004 |
| 95-th percentile | 2016 |
| Maximum | 2021 |
| Range | 171 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 31.770239 |
|---|---|
| Coefficient of variation (CV) | 0.016069001 |
| Kurtosis | -0.45641391 |
| Mean | 1977.1135 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | -0.65757831 |
| Sum | 7872866 |
| Variance | 1009.3481 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2016 | 266 | 6.7% |
| 2015 | 239 | 6.0% |
| 2004 | 104 | 2.6% |
| 1950 | 93 | 2.3% |
| 2003 | 90 | 2.3% |
| 1900 | 89 | 2.2% |
| 1952 | 83 | 2.1% |
| 1955 | 81 | 2.0% |
| 1920 | 78 | 2.0% |
| 2006 | 76 | 1.9% |
| Other values (107) | 2783 |
| Value | Count | Frequency (%) |
| 1850 | 1 | < 0.1% |
| 1880 | 1 | < 0.1% |
| 1889 | 1 | < 0.1% |
| 1900 | 89 | |
| 1904 | 1 | < 0.1% |
| 1905 | 7 | 0.2% |
| 1907 | 3 | 0.1% |
| 1908 | 4 | 0.1% |
| 1909 | 4 | 0.1% |
| 1910 | 52 |
| Value | Count | Frequency (%) |
| 2021 | 4 | 0.1% |
| 2020 | 1 | < 0.1% |
| 2016 | 266 | |
| 2015 | 239 | |
| 2014 | 40 | 1.0% |
| 2013 | 36 | 0.9% |
| 2012 | 32 | 0.8% |
| 2011 | 23 | 0.6% |
| 2010 | 31 | 0.8% |
| 2009 | 31 | 0.8% |
condition
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.68311569 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 0.66666667 |
| median | 0.66666667 |
| Q3 | 0.66666667 |
| 95-th percentile | 0.83333333 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.082617 |
|---|---|
| Coefficient of variation (CV) | 0.12094145 |
| Kurtosis | 4.0473958 |
| Mean | 0.68311569 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.19077285 |
| Sum | 2720.1667 |
| Variance | 0.0068255687 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0.666666667 | 3064 | |
| 0.833333333 | 660 | 16.6% |
| 0.5 | 234 | 5.9% |
| 0.333333333 | 15 | 0.4% |
| 1 | 5 | 0.1% |
| 0.166666667 | 3 | 0.1% |
| 0 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.166666667 | 3 | 0.1% |
| 0.333333333 | 15 | 0.4% |
| 0.5 | 234 | 5.9% |
| 0.666666667 | 3064 | |
| 0.833333333 | 660 | 16.6% |
| 1 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 5 | 0.1% |
| 0.833333333 | 660 | 16.6% |
| 0.666666667 | 3064 | |
| 0.5 | 234 | 5.9% |
| 0.333333333 | 15 | 0.4% |
| 0.166666667 | 3 | 0.1% |
| 0 | 1 | < 0.1% |
grade
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.38302361 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 18 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.2 |
| Q1 | 0.4 |
| median | 0.4 |
| Q3 | 0.4 |
| 95-th percentile | 0.6 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.097664765 |
|---|---|
| Coefficient of variation (CV) | 0.25498367 |
| Kurtosis | 3.2489524 |
| Mean | 0.38302361 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.176603 |
| Sum | 1525.2 |
| Variance | 0.0095384064 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0.4 | 3110 | |
| 0.2 | 586 | 14.7% |
| 0.6 | 254 | 6.4% |
| 0 | 18 | 0.5% |
| 0.8 | 12 | 0.3% |
| 1 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 18 | 0.5% |
| 0.2 | 586 | 14.7% |
| 0.4 | 3110 | |
| 0.6 | 254 | 6.4% |
| 0.8 | 12 | 0.3% |
| 1 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2 | 0.1% |
| 0.8 | 12 | 0.3% |
| 0.6 | 254 | 6.4% |
| 0.4 | 3110 | |
| 0.2 | 586 | 14.7% |
| 0 | 18 | 0.5% |
price
Real number (ℝ)
High correlation
| Distinct | 1349 |
|---|---|
| Distinct (%) | 33.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 209741.18 |
| Minimum | 29000 |
|---|---|
| Maximum | 2122450 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.2 KiB |
Quantile statistics
| Minimum | 29000 |
|---|---|
| 5-th percentile | 93000 |
| Q1 | 135000 |
| median | 179000 |
| Q3 | 257375 |
| 95-th percentile | 415000 |
| Maximum | 2122450 |
| Range | 2093450 |
| Interquartile range (IQR) | 122375 |
Descriptive statistics
| Standard deviation | 113511.24 |
|---|---|
| Coefficient of variation (CV) | 0.54119673 |
| Kurtosis | 25.319319 |
| Mean | 209741.18 |
| Median Absolute Deviation (MAD) | 53500 |
| Skewness | 2.9413621 |
| Sum | 8.3518937 × 108 |
| Variance | 1.2884802 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 115000 | 43 | 1.1% |
| 140000 | 38 | 1.0% |
| 145000 | 38 | 1.0% |
| 175000 | 37 | 0.9% |
| 160000 | 37 | 0.9% |
| 135000 | 36 | 0.9% |
| 130000 | 34 | 0.9% |
| 110000 | 31 | 0.8% |
| 150000 | 29 | 0.7% |
| 185000 | 29 | 0.7% |
| Other values (1339) | 3630 |
| Value | Count | Frequency (%) |
| 29000 | 1 | |
| 32000 | 1 | |
| 35000 | 1 | |
| 38000 | 1 | |
| 44000 | 1 | |
| 45000 | 1 | |
| 45150 | 1 | |
| 45550 | 1 | |
| 47000 | 1 | |
| 47800 | 1 |
| Value | Count | Frequency (%) |
| 2122450 | 1 | |
| 1000000 | 2 | |
| 925000 | 1 | |
| 910000 | 1 | |
| 900000 | 1 | |
| 887000 | 1 | |
| 842500 | 1 | |
| 825000 | 1 | |
| 800000 | 1 | |
| 792607.65 | 1 |
Interactions
Correlations
| bedrooms | condition | date | floors | grade | price | sqft_basement | sqft_living | sqft_lot | yr_built | |
|---|---|---|---|---|---|---|---|---|---|---|
| bedrooms | 1.000 | 0.015 | -0.001 | 0.261 | 0.357 | 0.322 | 0.085 | 0.505 | 0.202 | 0.171 |
| condition | 0.015 | 1.000 | 0.028 | 0.030 | 0.017 | 0.081 | -0.010 | 0.018 | 0.017 | -0.087 |
| date | -0.001 | 0.028 | 1.000 | 0.021 | 0.008 | 0.045 | 0.025 | 0.019 | 0.031 | 0.020 |
| floors | 0.261 | 0.030 | 0.021 | 1.000 | 0.201 | 0.143 | 0.242 | 0.319 | 0.113 | 0.207 |
| grade | 0.357 | 0.017 | 0.008 | 0.201 | 1.000 | 0.590 | 0.450 | 0.605 | 0.306 | 0.294 |
| price | 0.322 | 0.081 | 0.045 | 0.143 | 0.590 | 1.000 | 0.697 | 0.797 | 0.518 | 0.705 |
| sqft_basement | 0.085 | -0.010 | 0.025 | 0.242 | 0.450 | 0.697 | 1.000 | 0.531 | 0.411 | 0.495 |
| sqft_living | 0.505 | 0.018 | 0.019 | 0.319 | 0.605 | 0.797 | 0.531 | 1.000 | 0.470 | 0.406 |
| sqft_lot | 0.202 | 0.017 | 0.031 | 0.113 | 0.306 | 0.518 | 0.411 | 0.470 | 1.000 | 0.266 |
| yr_built | 0.171 | -0.087 | 0.020 | 0.207 | 0.294 | 0.705 | 0.495 | 0.406 | 0.266 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| date | floors | bedrooms | sqft_living | sqft_lot | sqft_basement | yr_built | condition | grade | price | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 160505 | 2 | 4 | 7391 | 56628 | 4635 | 1995 | 0.666667 | 1.0 | 2122450.0 |
| 1 | 161107 | 3 | 2 | 3231 | 80150 | 2931 | 1966 | 0.666667 | 0.4 | 385000.0 |
| 2 | 161022 | 2 | 5 | 3980 | 16988 | 2356 | 2009 | 0.833333 | 0.6 | 728000.0 |
| 3 | 161018 | 1.5 | 4 | 3557 | 876863 | 2050 | 2000 | 0.833333 | 0.6 | 842500.0 |
| 4 | 160922 | 1.5 | 3 | 3485 | 170320 | 2753 | 2013 | 0.666667 | 0.6 | 925000.0 |
| 5 | 160615 | 1 | 2 | 2020 | 12632 | 2020 | 1994 | 0.833333 | 0.6 | 431000.0 |
| 6 | 160627 | 1 | 2 | 2447 | 20909 | 2396 | 2003 | 0.833333 | 0.6 | 680000.0 |
| 7 | 161007 | 1 | 3 | 1189 | 13939 | 1189 | 2010 | 0.666667 | 0.4 | 228000.0 |
| 8 | 160414 | 3 | 3 | 2792 | 12197 | 1482 | 1966 | 0.666667 | 0.4 | 285000.0 |
| 9 | 160321 | 2 | 4 | 2284 | 8276 | 1002 | 2013 | 0.666667 | 0.4 | 279900.0 |
| date | floors | bedrooms | sqft_living | sqft_lot | sqft_basement | yr_built | condition | grade | price | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3972 | 160912 | 1 | 3 | 1162 | 6098 | 1146 | 2006 | 0.666667 | 0.4 | 175000.0 |
| 3973 | 161130 | 1 | 3 | 1140 | 6098 | 1100 | 2009 | 0.666667 | 0.4 | 170000.0 |
| 3974 | 160316 | 1 | 3 | 1200 | 6534 | 1176 | 2015 | 0.666667 | 0.4 | 186500.0 |
| 3975 | 161213 | 1 | 3 | 1154 | 6098 | 1060 | 1995 | 0.666667 | 0.4 | 170000.0 |
| 3976 | 160210 | 1.5 | 3 | 1273 | 6970 | 853 | 1994 | 0.666667 | 0.4 | 159000.0 |
| 3977 | 160105 | 1 | 3 | 1153 | 6970 | 1153 | 1995 | 0.666667 | 0.4 | 145200.0 |
| 3978 | 160311 | 2 | 3 | 1464 | 4356 | 812 | 1997 | 0.666667 | 0.4 | 169500.0 |
| 3979 | 160929 | 1 | 2 | 999 | 2614 | 981 | 2001 | 0.666667 | 0.4 | 127500.0 |
| 3980 | 160408 | 1 | 2 | 867 | 5227 | 867 | 2002 | 0.666667 | 0.2 | 142900.0 |
| 3981 | 160504 | 1 | 3 | 1272 | 8276 | 1272 | 2014 | 0.666667 | 0.4 | 196500.0 |
Duplicate rows
Most frequently occurring
| date | floors | bedrooms | sqft_living | sqft_lot | sqft_basement | yr_built | condition | grade | price | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | 160502 | 1 | 2 | 988 | 13939 | 988 | 1910 | 0.666667 | 0.4 | 85000.0 | 4 |
| 34 | 160512 | 1 | 2 | 925 | 8276 | 925 | 1959 | 0.666667 | 0.4 | 119900.0 | 4 |
| 49 | 160711 | 1 | 2 | 1448 | 74052 | 0 | 1900 | 0.833333 | 0.2 | 154900.0 | 4 |
| 71 | 161010 | 1 | 2 | 1552 | 10890 | 1275 | 1966 | 0.833333 | 0.4 | 199000.0 | 4 |
| 81 | 161108 | 1 | 1 | 2616 | 402059 | 1620 | 1978 | 0.500000 | 0.2 | 315000.0 | 4 |
| 82 | 161108 | 1 | 3 | 2616 | 402059 | 1620 | 2021 | 0.833333 | 0.2 | 315000.0 | 4 |
| 19 | 160325 | 1 | 2 | 966 | 5663 | 936 | 1933 | 0.500000 | 0.4 | 111000.0 | 3 |
| 23 | 160407 | 1 | 3 | 1617 | 107593 | 1608 | 2004 | 0.666667 | 0.4 | 275000.0 | 3 |
| 24 | 160413 | 1 | 3 | 1092 | 13939 | 660 | 1900 | 0.500000 | 0.4 | 89900.0 | 3 |
| 25 | 160418 | 1 | 3 | 1127 | 12197 | 1127 | 1958 | 0.666667 | 0.4 | 135000.0 | 3 |